package com.suyuan.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PigInExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PigInExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andGidIsNull() {
            addCriterion("GID is null");
            return (Criteria) this;
        }

        public Criteria andGidIsNotNull() {
            addCriterion("GID is not null");
            return (Criteria) this;
        }

        public Criteria andGidEqualTo(Integer value) {
            addCriterion("GID =", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidNotEqualTo(Integer value) {
            addCriterion("GID <>", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidGreaterThan(Integer value) {
            addCriterion("GID >", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidGreaterThanOrEqualTo(Integer value) {
            addCriterion("GID >=", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidLessThan(Integer value) {
            addCriterion("GID <", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidLessThanOrEqualTo(Integer value) {
            addCriterion("GID <=", value, "gid");
            return (Criteria) this;
        }

        public Criteria andGidIn(List<Integer> values) {
            addCriterion("GID in", values, "gid");
            return (Criteria) this;
        }

        public Criteria andGidNotIn(List<Integer> values) {
            addCriterion("GID not in", values, "gid");
            return (Criteria) this;
        }

        public Criteria andGidBetween(Integer value1, Integer value2) {
            addCriterion("GID between", value1, value2, "gid");
            return (Criteria) this;
        }

        public Criteria andGidNotBetween(Integer value1, Integer value2) {
            addCriterion("GID not between", value1, value2, "gid");
            return (Criteria) this;
        }

        public Criteria andPurGidIsNull() {
            addCriterion("Pur_GID is null");
            return (Criteria) this;
        }

        public Criteria andPurGidIsNotNull() {
            addCriterion("Pur_GID is not null");
            return (Criteria) this;
        }

        public Criteria andPurGidEqualTo(Integer value) {
            addCriterion("Pur_GID =", value, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidNotEqualTo(Integer value) {
            addCriterion("Pur_GID <>", value, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidGreaterThan(Integer value) {
            addCriterion("Pur_GID >", value, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidGreaterThanOrEqualTo(Integer value) {
            addCriterion("Pur_GID >=", value, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidLessThan(Integer value) {
            addCriterion("Pur_GID <", value, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidLessThanOrEqualTo(Integer value) {
            addCriterion("Pur_GID <=", value, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidIn(List<Integer> values) {
            addCriterion("Pur_GID in", values, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidNotIn(List<Integer> values) {
            addCriterion("Pur_GID not in", values, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidBetween(Integer value1, Integer value2) {
            addCriterion("Pur_GID between", value1, value2, "purGid");
            return (Criteria) this;
        }

        public Criteria andPurGidNotBetween(Integer value1, Integer value2) {
            addCriterion("Pur_GID not between", value1, value2, "purGid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidIsNull() {
            addCriterion("Are_AreaID is null");
            return (Criteria) this;
        }

        public Criteria andAreAreaidIsNotNull() {
            addCriterion("Are_AreaID is not null");
            return (Criteria) this;
        }

        public Criteria andAreAreaidEqualTo(Integer value) {
            addCriterion("Are_AreaID =", value, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidNotEqualTo(Integer value) {
            addCriterion("Are_AreaID <>", value, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidGreaterThan(Integer value) {
            addCriterion("Are_AreaID >", value, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidGreaterThanOrEqualTo(Integer value) {
            addCriterion("Are_AreaID >=", value, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidLessThan(Integer value) {
            addCriterion("Are_AreaID <", value, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidLessThanOrEqualTo(Integer value) {
            addCriterion("Are_AreaID <=", value, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidIn(List<Integer> values) {
            addCriterion("Are_AreaID in", values, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidNotIn(List<Integer> values) {
            addCriterion("Are_AreaID not in", values, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidBetween(Integer value1, Integer value2) {
            addCriterion("Are_AreaID between", value1, value2, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andAreAreaidNotBetween(Integer value1, Integer value2) {
            addCriterion("Are_AreaID not between", value1, value2, "areAreaid");
            return (Criteria) this;
        }

        public Criteria andInweightIsNull() {
            addCriterion("InWeight is null");
            return (Criteria) this;
        }

        public Criteria andInweightIsNotNull() {
            addCriterion("InWeight is not null");
            return (Criteria) this;
        }

        public Criteria andInweightEqualTo(Float value) {
            addCriterion("InWeight =", value, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightNotEqualTo(Float value) {
            addCriterion("InWeight <>", value, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightGreaterThan(Float value) {
            addCriterion("InWeight >", value, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightGreaterThanOrEqualTo(Float value) {
            addCriterion("InWeight >=", value, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightLessThan(Float value) {
            addCriterion("InWeight <", value, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightLessThanOrEqualTo(Float value) {
            addCriterion("InWeight <=", value, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightIn(List<Float> values) {
            addCriterion("InWeight in", values, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightNotIn(List<Float> values) {
            addCriterion("InWeight not in", values, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightBetween(Float value1, Float value2) {
            addCriterion("InWeight between", value1, value2, "inweight");
            return (Criteria) this;
        }

        public Criteria andInweightNotBetween(Float value1, Float value2) {
            addCriterion("InWeight not between", value1, value2, "inweight");
            return (Criteria) this;
        }

        public Criteria andWeightunitIsNull() {
            addCriterion("WeightUnit is null");
            return (Criteria) this;
        }

        public Criteria andWeightunitIsNotNull() {
            addCriterion("WeightUnit is not null");
            return (Criteria) this;
        }

        public Criteria andWeightunitEqualTo(String value) {
            addCriterion("WeightUnit =", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotEqualTo(String value) {
            addCriterion("WeightUnit <>", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitGreaterThan(String value) {
            addCriterion("WeightUnit >", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitGreaterThanOrEqualTo(String value) {
            addCriterion("WeightUnit >=", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitLessThan(String value) {
            addCriterion("WeightUnit <", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitLessThanOrEqualTo(String value) {
            addCriterion("WeightUnit <=", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitLike(String value) {
            addCriterion("WeightUnit like", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotLike(String value) {
            addCriterion("WeightUnit not like", value, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitIn(List<String> values) {
            addCriterion("WeightUnit in", values, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotIn(List<String> values) {
            addCriterion("WeightUnit not in", values, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitBetween(String value1, String value2) {
            addCriterion("WeightUnit between", value1, value2, "weightunit");
            return (Criteria) this;
        }

        public Criteria andWeightunitNotBetween(String value1, String value2) {
            addCriterion("WeightUnit not between", value1, value2, "weightunit");
            return (Criteria) this;
        }

        public Criteria andGradeIsNull() {
            addCriterion("Grade is null");
            return (Criteria) this;
        }

        public Criteria andGradeIsNotNull() {
            addCriterion("Grade is not null");
            return (Criteria) this;
        }

        public Criteria andGradeEqualTo(String value) {
            addCriterion("Grade =", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotEqualTo(String value) {
            addCriterion("Grade <>", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThan(String value) {
            addCriterion("Grade >", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeGreaterThanOrEqualTo(String value) {
            addCriterion("Grade >=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThan(String value) {
            addCriterion("Grade <", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLessThanOrEqualTo(String value) {
            addCriterion("Grade <=", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeLike(String value) {
            addCriterion("Grade like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotLike(String value) {
            addCriterion("Grade not like", value, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeIn(List<String> values) {
            addCriterion("Grade in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotIn(List<String> values) {
            addCriterion("Grade not in", values, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeBetween(String value1, String value2) {
            addCriterion("Grade between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andGradeNotBetween(String value1, String value2) {
            addCriterion("Grade not between", value1, value2, "grade");
            return (Criteria) this;
        }

        public Criteria andIntimeIsNull() {
            addCriterion("InTime is null");
            return (Criteria) this;
        }

        public Criteria andIntimeIsNotNull() {
            addCriterion("InTime is not null");
            return (Criteria) this;
        }

        public Criteria andIntimeEqualTo(Date value) {
            addCriterion("InTime =", value, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeNotEqualTo(Date value) {
            addCriterion("InTime <>", value, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeGreaterThan(Date value) {
            addCriterion("InTime >", value, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeGreaterThanOrEqualTo(Date value) {
            addCriterion("InTime >=", value, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeLessThan(Date value) {
            addCriterion("InTime <", value, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeLessThanOrEqualTo(Date value) {
            addCriterion("InTime <=", value, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeIn(List<Date> values) {
            addCriterion("InTime in", values, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeNotIn(List<Date> values) {
            addCriterion("InTime not in", values, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeBetween(Date value1, Date value2) {
            addCriterion("InTime between", value1, value2, "intime");
            return (Criteria) this;
        }

        public Criteria andIntimeNotBetween(Date value1, Date value2) {
            addCriterion("InTime not between", value1, value2, "intime");
            return (Criteria) this;
        }

        public Criteria andComGidIsNull() {
            addCriterion("Com_GID is null");
            return (Criteria) this;
        }

        public Criteria andComGidIsNotNull() {
            addCriterion("Com_GID is not null");
            return (Criteria) this;
        }

        public Criteria andComGidEqualTo(Integer value) {
            addCriterion("Com_GID =", value, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidNotEqualTo(Integer value) {
            addCriterion("Com_GID <>", value, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidGreaterThan(Integer value) {
            addCriterion("Com_GID >", value, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidGreaterThanOrEqualTo(Integer value) {
            addCriterion("Com_GID >=", value, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidLessThan(Integer value) {
            addCriterion("Com_GID <", value, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidLessThanOrEqualTo(Integer value) {
            addCriterion("Com_GID <=", value, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidIn(List<Integer> values) {
            addCriterion("Com_GID in", values, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidNotIn(List<Integer> values) {
            addCriterion("Com_GID not in", values, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidBetween(Integer value1, Integer value2) {
            addCriterion("Com_GID between", value1, value2, "comGid");
            return (Criteria) this;
        }

        public Criteria andComGidNotBetween(Integer value1, Integer value2) {
            addCriterion("Com_GID not between", value1, value2, "comGid");
            return (Criteria) this;
        }

        public Criteria andReceivernameIsNull() {
            addCriterion("ReceiverName is null");
            return (Criteria) this;
        }

        public Criteria andReceivernameIsNotNull() {
            addCriterion("ReceiverName is not null");
            return (Criteria) this;
        }

        public Criteria andReceivernameEqualTo(String value) {
            addCriterion("ReceiverName =", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameNotEqualTo(String value) {
            addCriterion("ReceiverName <>", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameGreaterThan(String value) {
            addCriterion("ReceiverName >", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameGreaterThanOrEqualTo(String value) {
            addCriterion("ReceiverName >=", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameLessThan(String value) {
            addCriterion("ReceiverName <", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameLessThanOrEqualTo(String value) {
            addCriterion("ReceiverName <=", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameLike(String value) {
            addCriterion("ReceiverName like", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameNotLike(String value) {
            addCriterion("ReceiverName not like", value, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameIn(List<String> values) {
            addCriterion("ReceiverName in", values, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameNotIn(List<String> values) {
            addCriterion("ReceiverName not in", values, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameBetween(String value1, String value2) {
            addCriterion("ReceiverName between", value1, value2, "receivername");
            return (Criteria) this;
        }

        public Criteria andReceivernameNotBetween(String value1, String value2) {
            addCriterion("ReceiverName not between", value1, value2, "receivername");
            return (Criteria) this;
        }

        public Criteria andComGid2IsNull() {
            addCriterion("Com_GID2 is null");
            return (Criteria) this;
        }

        public Criteria andComGid2IsNotNull() {
            addCriterion("Com_GID2 is not null");
            return (Criteria) this;
        }

        public Criteria andComGid2EqualTo(Integer value) {
            addCriterion("Com_GID2 =", value, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2NotEqualTo(Integer value) {
            addCriterion("Com_GID2 <>", value, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2GreaterThan(Integer value) {
            addCriterion("Com_GID2 >", value, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2GreaterThanOrEqualTo(Integer value) {
            addCriterion("Com_GID2 >=", value, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2LessThan(Integer value) {
            addCriterion("Com_GID2 <", value, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2LessThanOrEqualTo(Integer value) {
            addCriterion("Com_GID2 <=", value, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2In(List<Integer> values) {
            addCriterion("Com_GID2 in", values, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2NotIn(List<Integer> values) {
            addCriterion("Com_GID2 not in", values, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2Between(Integer value1, Integer value2) {
            addCriterion("Com_GID2 between", value1, value2, "comGid2");
            return (Criteria) this;
        }

        public Criteria andComGid2NotBetween(Integer value1, Integer value2) {
            addCriterion("Com_GID2 not between", value1, value2, "comGid2");
            return (Criteria) this;
        }

        public Criteria andSupplynameIsNull() {
            addCriterion("SupplyName is null");
            return (Criteria) this;
        }

        public Criteria andSupplynameIsNotNull() {
            addCriterion("SupplyName is not null");
            return (Criteria) this;
        }

        public Criteria andSupplynameEqualTo(String value) {
            addCriterion("SupplyName =", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameNotEqualTo(String value) {
            addCriterion("SupplyName <>", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameGreaterThan(String value) {
            addCriterion("SupplyName >", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameGreaterThanOrEqualTo(String value) {
            addCriterion("SupplyName >=", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameLessThan(String value) {
            addCriterion("SupplyName <", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameLessThanOrEqualTo(String value) {
            addCriterion("SupplyName <=", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameLike(String value) {
            addCriterion("SupplyName like", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameNotLike(String value) {
            addCriterion("SupplyName not like", value, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameIn(List<String> values) {
            addCriterion("SupplyName in", values, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameNotIn(List<String> values) {
            addCriterion("SupplyName not in", values, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameBetween(String value1, String value2) {
            addCriterion("SupplyName between", value1, value2, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplynameNotBetween(String value1, String value2) {
            addCriterion("SupplyName not between", value1, value2, "supplyname");
            return (Criteria) this;
        }

        public Criteria andSupplytelIsNull() {
            addCriterion("SupplyTel is null");
            return (Criteria) this;
        }

        public Criteria andSupplytelIsNotNull() {
            addCriterion("SupplyTel is not null");
            return (Criteria) this;
        }

        public Criteria andSupplytelEqualTo(String value) {
            addCriterion("SupplyTel =", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelNotEqualTo(String value) {
            addCriterion("SupplyTel <>", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelGreaterThan(String value) {
            addCriterion("SupplyTel >", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelGreaterThanOrEqualTo(String value) {
            addCriterion("SupplyTel >=", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelLessThan(String value) {
            addCriterion("SupplyTel <", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelLessThanOrEqualTo(String value) {
            addCriterion("SupplyTel <=", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelLike(String value) {
            addCriterion("SupplyTel like", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelNotLike(String value) {
            addCriterion("SupplyTel not like", value, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelIn(List<String> values) {
            addCriterion("SupplyTel in", values, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelNotIn(List<String> values) {
            addCriterion("SupplyTel not in", values, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelBetween(String value1, String value2) {
            addCriterion("SupplyTel between", value1, value2, "supplytel");
            return (Criteria) this;
        }

        public Criteria andSupplytelNotBetween(String value1, String value2) {
            addCriterion("SupplyTel not between", value1, value2, "supplytel");
            return (Criteria) this;
        }

        public Criteria andBuyplaceIsNull() {
            addCriterion("BuyPlace is null");
            return (Criteria) this;
        }

        public Criteria andBuyplaceIsNotNull() {
            addCriterion("BuyPlace is not null");
            return (Criteria) this;
        }

        public Criteria andBuyplaceEqualTo(String value) {
            addCriterion("BuyPlace =", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceNotEqualTo(String value) {
            addCriterion("BuyPlace <>", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceGreaterThan(String value) {
            addCriterion("BuyPlace >", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceGreaterThanOrEqualTo(String value) {
            addCriterion("BuyPlace >=", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceLessThan(String value) {
            addCriterion("BuyPlace <", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceLessThanOrEqualTo(String value) {
            addCriterion("BuyPlace <=", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceLike(String value) {
            addCriterion("BuyPlace like", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceNotLike(String value) {
            addCriterion("BuyPlace not like", value, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceIn(List<String> values) {
            addCriterion("BuyPlace in", values, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceNotIn(List<String> values) {
            addCriterion("BuyPlace not in", values, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceBetween(String value1, String value2) {
            addCriterion("BuyPlace between", value1, value2, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuyplaceNotBetween(String value1, String value2) {
            addCriterion("BuyPlace not between", value1, value2, "buyplace");
            return (Criteria) this;
        }

        public Criteria andBuysnIsNull() {
            addCriterion("BuySN is null");
            return (Criteria) this;
        }

        public Criteria andBuysnIsNotNull() {
            addCriterion("BuySN is not null");
            return (Criteria) this;
        }

        public Criteria andBuysnEqualTo(String value) {
            addCriterion("BuySN =", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnNotEqualTo(String value) {
            addCriterion("BuySN <>", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnGreaterThan(String value) {
            addCriterion("BuySN >", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnGreaterThanOrEqualTo(String value) {
            addCriterion("BuySN >=", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnLessThan(String value) {
            addCriterion("BuySN <", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnLessThanOrEqualTo(String value) {
            addCriterion("BuySN <=", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnLike(String value) {
            addCriterion("BuySN like", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnNotLike(String value) {
            addCriterion("BuySN not like", value, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnIn(List<String> values) {
            addCriterion("BuySN in", values, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnNotIn(List<String> values) {
            addCriterion("BuySN not in", values, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnBetween(String value1, String value2) {
            addCriterion("BuySN between", value1, value2, "buysn");
            return (Criteria) this;
        }

        public Criteria andBuysnNotBetween(String value1, String value2) {
            addCriterion("BuySN not between", value1, value2, "buysn");
            return (Criteria) this;
        }

        public Criteria andNoteIsNull() {
            addCriterion("Note is null");
            return (Criteria) this;
        }

        public Criteria andNoteIsNotNull() {
            addCriterion("Note is not null");
            return (Criteria) this;
        }

        public Criteria andNoteEqualTo(String value) {
            addCriterion("Note =", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotEqualTo(String value) {
            addCriterion("Note <>", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThan(String value) {
            addCriterion("Note >", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteGreaterThanOrEqualTo(String value) {
            addCriterion("Note >=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThan(String value) {
            addCriterion("Note <", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLessThanOrEqualTo(String value) {
            addCriterion("Note <=", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteLike(String value) {
            addCriterion("Note like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotLike(String value) {
            addCriterion("Note not like", value, "note");
            return (Criteria) this;
        }

        public Criteria andNoteIn(List<String> values) {
            addCriterion("Note in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotIn(List<String> values) {
            addCriterion("Note not in", values, "note");
            return (Criteria) this;
        }

        public Criteria andNoteBetween(String value1, String value2) {
            addCriterion("Note between", value1, value2, "note");
            return (Criteria) this;
        }

        public Criteria andNoteNotBetween(String value1, String value2) {
            addCriterion("Note not between", value1, value2, "note");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}